Re: Calling a function via ODBC

Can you point me to some C examples?
Thanks

>?Valerio Ferrucci wrote:
>>
>>  Hi,
>>  I have postgres installed on my Machine (MacOSX) and connect to it
>>via ODBC from my C app.
>>  All works ok (select, insert, update and so on).
>>
>>  Now I made the following simple function:
>>  CREATE OR REPLACE FUNCTION concat_text (TEXT, TEXT) RETURNS TEXT AS '
>>  BEGIN
>>  RETURN $1 || $2;
>>  END;
>>  ' LANGUAGE 'plpgsql';
>>
>>  and called it succesfully doing:
>>  SQLExecDirect(... ""select concat_text('val', 'erio')"" ...)
>>  and fetching the result with SQLFetchScroll etc..., all works ok.
>>
>>  SO WHICH IS THE QUESTION?
>>  THE QUESTION IS:
>>  Is there a way to call my func using the ODBC syntax:
>  > {? = CALL concat_text(?, ?)}
>>  using SQLBindParameter to bind variable (input/output) to '?'
>>  and getting return value directly in a bound var (without any
>>  Fetch) (see http://www.ddart.net/mssql/sql70/odbcht10_1.htm )?
>
>Yes. As for your example, bind the 1st parameter
>as SQL_PARAM_OUTPUT and 2nd/3rd paramters as SQL_
>PARAM_INPUT.
>
>regards,
>Hiroshi Inoue
>    http://w2422.nsk.ne.jp/?inoue/


--
==================================================================
Valerio Ferrucci                        Tabasoft Sas
ferrucci@tabasoft.it                    http://www.tabasoft.it